-
(0 / 300)
경영자동화 검색결과 3건
-
생산 및 원료수불, 재고 관리 프로그램(LOT번호, 선입선출, 동시공유) 경영자동화 > 자재·생산 | 조회 3,750추천업무 동시공유 , Lot번호 , 생산 , BOM , 재고관리 , 판매 , 수불관리 , 배합정보 , 품의서 , 구매리스트 , 제품생산 , 제품판매 , 생산일지 , 원료수불 , 제품거래내역 , 제품생산출한 , BASIC다수 사용자의 사용이 제한되는 "읽기전용" 의해 기능 제한을 개선하기위해 동시공유 기능을 추가하였습니다.원료, 제품 정보 및 입고처, 출고처 정보를 입력하시면 원료의 입고와 LOT번호 부여, 제품의 생산판매에서 기록되는 데이터로 품목별 원료수불내역과 LOT번호 역추적, 제품거래내역, 월별 제품재고현황을 자동으로 관리할 수 있습니다. 구매품의서와 구매리스트 작성으로 원료를 입고처리할 수 있습니다.제품에 대한 배합정보를 입력하면 저장된 배합정보 데이터를 바탕으로 생산일지를 간편하게 관리할 수 있습니다.
업무자동화 검색결과 10건
표준엑셀 검색결과 167건
-
영문 의향서(LOI, NO PAYMENT AT SIGNING) 영문 의향서(LOI, NO PAYMENT AT SIGNING) 표준엑셀 서식입니다.
-
영문 의향서(LOI, OPTIONAL PAYMENT AT SIGNING) 영문 의향서(LOI, OPTIONAL PAYMENT AT SIGNING) 표준엑셀 서식입니다.
-
Noold'>tificaold'>tion Form Authority Applicaold'>tion Form for a Change Noold'>tificaold'>tion Form Authority Applicaold'>tion Form for a Change 표준엑셀 서식입니다.
맞춤제작 전문가 답변 검색결과 4,209건
-
자재 입출고 및 재고 현황+ 재고검색
1.업종 : 수입차전문 정비업
>2.예산 : 100~200만원ng>
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>안녕하세요
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>수입차 정비를 전문하고 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>조이오토 리페어 입니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>저희 매장에서 정비시 필요한 자재를
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>많이 가지고 있는데
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그중 필터류의 종류가 상당히 많습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필터류의 입,출고 현황과 재고파악이
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>가능한 프로그램이 필요합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그중 제일 중요한게 재고로 보유하고 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필터를 검색하는 기능이 꼭 있어야 합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>예를들면 한가지의 필터를 검색할수 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>조건이 여러가지로 가능해야 합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>차량모델명, 엔진코드, 정품품번,
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>타메이커품번 등등으로 검색을 하여
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현재 재고가 있는지 확인이 가능해야합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>여러 입출고 프로그램을 확인해 봤지만
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>보유하고 있는 부품에 대한 호환성여부 및
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>검색 조건을 충족하는 프로그램이 없어서
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>문의드립니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그리고 한가지더 있는데
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>바코드로 입출고 체크를 하고 싶습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현장에서 작업자들이 부품 재고 여부확인후
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>찾은 부품을 바코드를 찍어 출고가 체크되고
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>최소 수량이 남았을때 발주할수 있게
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>확인이 되었으면 좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>또한 재고부족으로 추가 발주하여
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>부품입고시 바코드생성및 인쇄를 통해
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>입고 부품을 빠르게 정리할수 있었으면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>위 사항이 가능하다면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>바코드 프린터까지 구매 혹은 렌탈로
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현장에서의 작업을 수월하게 했으면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>참고로 엑셀도 모르고 바코드 기계도
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>사용안해봤지만 꼭 저희매장에
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필요한 프로그램이 있었으면 좋겠습니다.
답변부탁드립다.
-
맞춤제작 의뢰드립니다
회원제 먹거리 쇼핑몰을 운영하고 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing
:0.0pt;mso-text-raise:0.0pt;">.ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">6개 품목을 고객이 원하는 수량으로 포장해서 매월 정기적으로 배송하고 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객 주문정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">DB를 관리하는 기능이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 고객코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/이름ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/연락처ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/주소
주문품목과 수량 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 예ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">) 1번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 2번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 3번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 4번품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개
입금정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 카드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">or자동이체ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">or계좌입금 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 매월 입금한 내역과 액수
대략 이정도의 항목이고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전체고객은 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">500명 정도 됩니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
첨부한 액셀파일과 같은 양식으로 관리를 하고 있으며ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,
매월 배송할 날짜가 되면 이 파일을 출력하여 포장팀에게 전달해야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
문제는ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 주문품목을 고객들께서 수시로 변경하신다는 겁니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
전화로 변경요청을 받으면 액셀파일에서 해당고객을 찾아서 제품수량을 변경하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 변경이 없는 고객은 전달의 주문정보를 그대로 이월하여 처리합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
그래서ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 매월 정해진 날에 발송업무가 끝나면 그 달 배송리스트를 액셀로 저장하여 백업을 해둡니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">. 예를 들어 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">25일에 출고가 끝나면ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 그때까지 리스트를 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘11월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’파일로 저장하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 11월 파일을 카피하여 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월 변경사항을 한 달 동안 적용시켜서 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">25일에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘12월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’파일을 저장하는 식이에요
그러다보니 특정고객을 검색하여ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 이 고객이 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">9월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,10월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,11월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,12월에 어떻게 배송 받았는지 조회를 해보고자 할 때 굉장히 번거롭습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 기존 액셀파일이 깔끔하질 못해서ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 고객님들의 주문변경요청 전화를 받을 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전산에서 바로 작업하질 못하고 수기로 작성한 다음에 액셀파일에 두 번 수정을 하고 있는데
이러다보니 빼먹는 부분도 생기고 여러 가지로 번거러움이 큽니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
업무자동화서식중에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">“고객 상담관리 업무자동화 프로그램ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">(상담구분별 월별현황ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">)” 프로그램을 다운받아서 사용하고 있는데ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 고객정보가 월별로 나뉘지 않고 한 파일에 다 저장되니 고객이름으로 검색했을 때 현재까지 상담한 내용을 모두 확인가능해서 참 편리합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
이 프로그램에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘주문정보ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’ 항목을 추가해서
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">0개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개
위와 같은 정보를 삽입하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 또 상담내역과 함께 조회할 수 있는 프로그램이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또 이 정보를 월별로 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">export와 출력할 수 있는 기능이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객 이름으로 검색했을 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 해당 고객의 월별 리스트와ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상담했던 리스트ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 한 달에 여러 번 상담내역이 있다면 그 여러 번의 상담내역을 모두 알 수 있어야 하고
월별로 검색했을 때는 해당 월의 모든 고객의 내역을 볼 수 있어야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 제품 포장 조합에 따라 상품코드가 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">. 상품코드에 따른 검색결과도 출력가능해야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월 내역을 출력할 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전체내역ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">... 의 내역을 각각 액셀파일로 추출할 수 있는 기능도 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
한가지 더ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 입금내역입니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객마다 월별로 입금한 내역과 금액을 한 시트에서 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1년치를 볼수 있어야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
기본 시트에 누적된 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">DB에서 금액부분만 뽑아서 별도시트에 연동시켜서 모든 고객의 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1~12월까지의 입금내역을 볼 수 있는ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.... 아래와 같은 시트가 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">6월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">8월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">9월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월
김은영
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
유지민
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
업무과정에서 불편했던 내용들을 서술해 봤습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
적당한 프로그램이 있는지ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 혹은 커스터마이징 컨설팅이나ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 필요하면 주문제작을 하고 싶습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
비용과 기간도 안내부탁드립니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">!
KaKao ID 친구추가 : @coukey 
